/*
 Navicat Premium Data Transfer

 Source Server         : usefullc_prod
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : usefullc_demo

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 08/06/2022 10:27:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for demo
-- ----------------------------
DROP TABLE IF EXISTS `demo`;
CREATE TABLE `demo` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `content` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of demo
-- ----------------------------
BEGIN;
INSERT INTO `demo` VALUES (1, b'1', '2022-06-06 10:01:32.171000', '2022-06-06 10:01:32.171000', '示例内容111', '示例标题1', 1);
INSERT INTO `demo` VALUES (2, b'1', '2022-06-06 10:03:05.656000', '2022-06-06 10:03:05.656000', '测试内容2', '测试标题2', 0);
INSERT INTO `demo` VALUES (3, b'0', '2022-06-06 10:03:24.290000', '2022-06-06 10:03:24.290000', 'test3333', 'test3', 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_app_device
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_device`;
CREATE TABLE `sys_app_device` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `appName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `appVersion` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `clientIp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `deviceHeight` int NOT NULL,
  `deviceId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `deviceVersion` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `deviceWidth` int NOT NULL,
  `local` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `platform` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `systemName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `systemVersion` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for sys_app_version
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_version`;
CREATE TABLE `sys_app_version` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `appName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `companyId` bigint DEFAULT NULL,
  `forceUpdate` bit(1) NOT NULL,
  `model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` int NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `updateLog` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `versionNo` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for sys_app_version_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_version_item`;
CREATE TABLE `sys_app_version_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `appUrl` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `appVersionId` bigint NOT NULL,
  `platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `platformVersion` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKp929pv6wfhh9g2jqiyc5rp0te` (`appVersionId`) USING BTREE,
  CONSTRAINT `FKp929pv6wfhh9g2jqiyc5rp0te` FOREIGN KEY (`appVersionId`) REFERENCES `sys_app_version` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for sys_data_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_config`;
CREATE TABLE `sys_data_config` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `enable` bit(1) NOT NULL,
  `value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_data_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_data_config` VALUES (4, b'1', '2022-04-18 22:35:16.968000', '2022-04-18 22:39:26.919000', '11', b'1', '22', '33');
INSERT INTO `sys_data_config` VALUES (5, b'1', '2022-06-03 10:56:28.718000', '2022-06-03 10:56:28.718000', 'aaa', b'1', 'a1', 'a2');
COMMIT;

-- ----------------------------
-- Table structure for sys_data_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_dict`;
CREATE TABLE `sys_data_dict` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `parentId` bigint NOT NULL,
  `value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `orderNo` int NOT NULL,
  `type` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_h2svxnxo6t92o92rc38f3wcqd` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_data_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_data_dict` VALUES (1, b'1', '2022-04-17 10:12:27.971000', '2022-04-17 10:12:27.971000', '0005', '111', 'aaa', 0, '1111', 1, 0);
INSERT INTO `sys_data_dict` VALUES (6, b'1', '2022-04-17 10:14:29.496000', '2022-04-17 10:14:29.496000', '0005000200020001', '111', 't6', 5, '6666', 2, 5);
INSERT INTO `sys_data_dict` VALUES (7, b'1', '2022-04-17 16:59:05.340000', '2022-06-02 10:34:34.820000', '0006', '用户状态', '用户状态', 0, 'userStatus', 1, 0);
INSERT INTO `sys_data_dict` VALUES (8, b'1', '2022-04-17 18:21:00.064000', '2022-06-02 10:35:08.098000', '00060002', '未激活', '未激活', 7, '0', 1, 0);
INSERT INTO `sys_data_dict` VALUES (11, b'1', '2022-04-24 11:56:42.168000', '2022-06-03 20:51:06.234000', '0007', 'C端用户职业', '职业', 0, 'career', 3, 5);
INSERT INTO `sys_data_dict` VALUES (12, b'1', '2022-04-24 12:03:25.233000', '2022-04-24 12:03:25.233000', '00070001', NULL, '互联网IT', 11, 'IT', 1, 5);
INSERT INTO `sys_data_dict` VALUES (13, b'1', '2022-04-24 12:03:57.112000', '2022-04-24 12:03:57.112000', '00070002', NULL, '金融', 11, 'finance', 2, 5);
INSERT INTO `sys_data_dict` VALUES (14, b'1', '2022-04-29 18:23:17.335000', '2022-04-29 18:23:17.335000', '0009', NULL, '性别', 0, 'gender', 4, 0);
INSERT INTO `sys_data_dict` VALUES (15, b'1', '2022-04-29 18:26:45.390000', '2022-04-29 18:27:29.739000', '00090003', NULL, '女', 14, '0', 1, 0);
INSERT INTO `sys_data_dict` VALUES (16, b'1', '2022-04-29 18:27:03.536000', '2022-04-29 18:27:03.536000', '00090002', NULL, '男', 14, '1', 2, 0);
INSERT INTO `sys_data_dict` VALUES (17, b'1', '2022-04-29 19:54:09.897000', '2022-06-03 20:50:42.598000', '0010', '数据类型', '数据类型', 0, 'dataType', 5, 5);
INSERT INTO `sys_data_dict` VALUES (18, b'1', '2022-04-29 19:56:12.827000', '2022-05-27 18:28:58.643000', '00100001', NULL, 'Long', 17, 'Long', 1, 5);
INSERT INTO `sys_data_dict` VALUES (19, b'1', '2022-04-29 19:56:28.690000', '2022-05-27 18:28:34.214000', '00100002', NULL, 'String', 17, 'String', 2, 5);
INSERT INTO `sys_data_dict` VALUES (20, b'1', '2022-05-27 18:29:11.032000', '2022-05-27 18:29:11.032000', '00100003', NULL, 'Integer', 17, 'Integer', 3, 5);
INSERT INTO `sys_data_dict` VALUES (21, b'1', '2022-05-27 18:29:29.246000', '2022-05-27 18:29:29.246000', '00100004', NULL, 'Date', 17, 'Date', 4, 5);
INSERT INTO `sys_data_dict` VALUES (22, b'1', '2022-05-27 18:30:14.241000', '2022-05-27 18:30:14.241000', '00100006', NULL, 'DateTime', 17, 'DateTime', 5, 5);
INSERT INTO `sys_data_dict` VALUES (23, b'1', '2022-05-27 18:30:45.004000', '2022-05-27 18:30:45.004000', '00100007', NULL, 'BigDecimal', 17, 'BigDecimal', 6, 5);
INSERT INTO `sys_data_dict` VALUES (24, b'1', '2022-05-27 18:30:56.643000', '2022-05-27 18:30:56.643000', '00100008', NULL, 'Boolean', 17, 'Boolean', 7, 5);
INSERT INTO `sys_data_dict` VALUES (25, b'1', '2022-05-27 18:31:28.151000', '2022-05-27 18:31:28.151000', '00100009', NULL, 'Byte', 17, 'Byte', 8, 5);
INSERT INTO `sys_data_dict` VALUES (26, b'1', '2022-05-27 18:31:53.258000', '2022-05-27 18:31:53.258000', '00100010', NULL, 'StringText', 17, 'StringText', 10, 5);
INSERT INTO `sys_data_dict` VALUES (27, b'1', '2022-06-02 10:35:32.560000', '2022-06-02 10:35:32.560000', '00060003', '已激活', '已激活', 7, '1', 2, 0);
INSERT INTO `sys_data_dict` VALUES (28, b'1', '2022-06-02 10:35:50.145000', '2022-06-02 10:35:50.145000', '00060004', '冻结', '冻结', 7, '2', 3, 0);
INSERT INTO `sys_data_dict` VALUES (29, b'1', '2022-06-03 11:00:54.420000', '2022-06-03 11:00:54.420000', '000500020004', '1', 't2a', 3, 't2a1', 1, 5);
INSERT INTO `sys_data_dict` VALUES (30, b'1', '2022-06-03 11:01:56.449000', '2022-06-03 18:26:19.018000', '0012', '字典数据类型', '字典数据类型', 0, 'dataDictType', 1, 0);
INSERT INTO `sys_data_dict` VALUES (31, b'1', '2022-06-03 11:17:19.984000', '2022-06-03 11:19:01.919000', '0014', '是否', '是否', 0, 'yesNoNumber', 6, 0);
INSERT INTO `sys_data_dict` VALUES (32, b'1', '2022-06-03 11:18:17.692000', '2022-06-03 11:18:17.692000', '00140001', '是', '是', 31, '1', 1, 0);
INSERT INTO `sys_data_dict` VALUES (33, b'1', '2022-06-03 11:18:36.610000', '2022-06-03 11:18:36.610000', '00140002', '否', '否', 31, '0', 2, 0);
INSERT INTO `sys_data_dict` VALUES (34, b'1', '2022-06-03 11:19:48.046000', '2022-06-03 11:19:48.046000', '0015', '菜单类型', '菜单类型', 0, 'menuType', 7, 0);
INSERT INTO `sys_data_dict` VALUES (35, b'1', '2022-06-03 11:20:17.047000', '2022-06-03 11:20:17.047000', '00150001', '菜单', '菜单', 34, '1', 1, 0);
INSERT INTO `sys_data_dict` VALUES (36, b'1', '2022-06-03 11:20:30.419000', '2022-06-03 11:20:30.419000', '00150002', '按钮', '按钮', 34, '0', 2, 0);
INSERT INTO `sys_data_dict` VALUES (37, b'1', '2022-06-03 18:27:27.011000', '2022-06-03 18:27:27.011000', '00120002', '整数', '整数', 30, '0', 1, 0);
INSERT INTO `sys_data_dict` VALUES (38, b'1', '2022-06-03 18:27:56.446000', '2022-06-03 18:28:19.234000', '00120003', '长整', '长整', 30, '1', 2, 0);
INSERT INTO `sys_data_dict` VALUES (39, b'1', '2022-06-03 18:28:08.417000', '2022-06-03 18:28:23.762000', '00120004', '短整', '短整', 30, '2', 3, 0);
INSERT INTO `sys_data_dict` VALUES (40, b'1', '2022-06-03 18:28:43.988000', '2022-06-03 18:28:43.988000', '00120005', '双精度', '双精度', 30, '3', 4, 0);
INSERT INTO `sys_data_dict` VALUES (41, b'1', '2022-06-03 18:28:57.496000', '2022-06-03 18:28:57.496000', '00120006', '单精度', '单精度', 30, '4', 5, 0);
INSERT INTO `sys_data_dict` VALUES (42, b'1', '2022-06-03 18:29:10.285000', '2022-06-03 18:29:10.285000', '00120007', '字符', '字符', 30, '5', 6, 0);
INSERT INTO `sys_data_dict` VALUES (43, b'1', '2022-06-03 18:29:22.858000', '2022-06-03 18:29:22.858000', '00120008', '布尔', '布尔', 30, '6', 7, 0);
INSERT INTO `sys_data_dict` VALUES (44, b'1', '2022-06-03 18:29:34.191000', '2022-06-03 18:29:34.191000', '00120009', '字节', '字节', 30, '7', 8, 0);
INSERT INTO `sys_data_dict` VALUES (45, b'1', '2022-06-06 08:37:13.978000', '2022-06-06 08:37:22.275000', '0017', NULL, '应用类型', 0, 'appType', 8, 5);
INSERT INTO `sys_data_dict` VALUES (46, b'1', '2022-06-06 08:37:38.682000', '2022-06-06 08:37:38.682000', '00170001', NULL, '系统', 45, 'system', 1, 5);
INSERT INTO `sys_data_dict` VALUES (47, b'1', '2022-06-06 08:37:51.892000', '2022-06-06 08:37:51.892000', '00170002', NULL, '用户', 45, 'user', 2, 5);
INSERT INTO `sys_data_dict` VALUES (48, b'1', '2022-06-06 08:38:14.055000', '2022-06-06 08:38:14.055000', '00170003', NULL, '示例', 45, 'demo', 3, 5);
COMMIT;

-- ----------------------------
-- Table structure for sys_local_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_local_info`;
CREATE TABLE `sys_local_info` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `appType` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `type` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_local_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_local_info` VALUES (1, b'1', '2022-04-18 18:09:13.000000', '2022-04-18 18:09:16.000000', 'demo', 'org.hibernate.exception.ConstraintViolationException', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_local_info_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_local_info_detail`;
CREATE TABLE `sys_local_info_detail` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `infoId` bigint DEFAULT NULL,
  `language` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_local_info_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_local_info_detail` VALUES (1, b'1', '2022-04-18 18:07:46.000000', '2022-04-18 18:07:48.000000', '执行约束出错', 1, 'zh');
INSERT INTO `sys_local_info_detail` VALUES (2, b'1', '2022-04-18 18:11:15.000000', '2022-04-18 18:11:17.000000', 'could not execute statement', 1, 'en');
COMMIT;

-- ----------------------------
-- Table structure for sys_serial_number
-- ----------------------------
DROP TABLE IF EXISTS `sys_serial_number`;
CREATE TABLE `sys_serial_number` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `no` int NOT NULL,
  `tableName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_serial_number
-- ----------------------------
BEGIN;
INSERT INTO `sys_serial_number` VALUES (1, 17, 'sys_data_dict', '0', b'1', '2022-04-17 09:47:04.241000', '2022-04-17 09:47:04.241000');
INSERT INTO `sys_serial_number` VALUES (7, 2, 'sys_data_dict', '0001', b'1', '2022-04-17 09:58:27.543000', '2022-04-17 09:58:27.543000');
INSERT INTO `sys_serial_number` VALUES (8, 3, 'sys_data_dict', '0002', b'1', '2022-04-17 09:58:58.693000', '2022-04-17 09:58:58.693000');
INSERT INTO `sys_serial_number` VALUES (9, 2, 'sys_data_dict', '0005', b'1', '2022-04-17 10:13:18.346000', '2022-04-17 10:13:18.346000');
INSERT INTO `sys_serial_number` VALUES (10, 4, 'sys_data_dict', '00050002', b'1', '2022-04-17 10:13:51.613000', '2022-04-17 10:13:51.613000');
INSERT INTO `sys_serial_number` VALUES (11, 1, 'sys_data_dict', '000500020002', b'1', '2022-04-17 10:14:29.463000', '2022-04-17 10:14:29.463000');
INSERT INTO `sys_serial_number` VALUES (12, 4, 'sys_data_dict', '0006', b'1', '2022-04-17 18:20:59.867000', '2022-04-17 18:20:59.867000');
INSERT INTO `sys_serial_number` VALUES (13, 1, 'sys_data_dict', '00060001', b'1', '2022-04-17 20:00:17.007000', '2022-04-17 20:00:17.007000');
INSERT INTO `sys_serial_number` VALUES (14, 3, 'sys_data_dict', '00060002', b'1', '2022-04-17 20:01:22.846000', '2022-04-17 20:01:22.846000');
INSERT INTO `sys_serial_number` VALUES (15, 23, 'sys_auth_res', '0', b'1', '2022-04-18 10:03:42.006000', '2022-04-18 10:03:42.006000');
INSERT INTO `sys_serial_number` VALUES (16, 2, 'sys_auth_res', '0004', b'1', '2022-04-18 11:16:29.900000', '2022-04-18 11:16:29.900000');
INSERT INTO `sys_serial_number` VALUES (17, 3, 'sys_auth_res', '00040002', b'1', '2022-04-18 11:17:51.932000', '2022-04-18 11:17:51.932000');
INSERT INTO `sys_serial_number` VALUES (18, 4, 'sys_auth_res', '000400020001', b'1', '2022-04-18 18:20:32.211000', '2022-04-18 18:20:32.211000');
INSERT INTO `sys_serial_number` VALUES (19, 22, 'sys_auth_res', '0006', b'1', '2022-04-18 20:09:42.641000', '2022-04-18 20:09:42.641000');
INSERT INTO `sys_serial_number` VALUES (20, 21, 'sys_auth_res', '0005', b'1', '2022-04-18 20:12:09.643000', '2022-04-18 20:12:09.643000');
INSERT INTO `sys_serial_number` VALUES (21, 2, 'sys_data_dict', '0007', b'1', '2022-04-24 12:03:25.199000', '2022-04-24 12:03:25.199000');
INSERT INTO `sys_serial_number` VALUES (22, 4, 'sys_auth_res', '0009', b'1', '2022-04-27 11:15:19.991000', '2022-04-27 11:15:19.991000');
INSERT INTO `sys_serial_number` VALUES (23, 1, 'sys_auth_res', '0010', b'1', '2022-04-27 11:59:53.507000', '2022-04-27 11:59:53.507000');
INSERT INTO `sys_serial_number` VALUES (24, 2, 'sys_auth_res', '0012', b'1', '2022-04-27 17:34:59.433000', '2022-04-27 17:34:59.433000');
INSERT INTO `sys_serial_number` VALUES (25, 3, 'sys_data_dict', '0009', b'1', '2022-04-29 18:26:45.359000', '2022-04-29 18:26:45.359000');
INSERT INTO `sys_serial_number` VALUES (26, 10, 'sys_data_dict', '0010', b'1', '2022-04-29 19:56:12.801000', '2022-04-29 19:56:12.801000');
INSERT INTO `sys_serial_number` VALUES (27, 14, 'sys_auth_res', '00050017', b'1', '2022-05-24 16:23:22.016000', '2022-05-24 16:23:22.016000');
INSERT INTO `sys_serial_number` VALUES (28, 2, 'sys_auth_res', '000500170004', b'1', '2022-05-24 16:36:30.477000', '2022-05-24 16:36:30.477000');
INSERT INTO `sys_serial_number` VALUES (29, 7, 'sys_auth_res', '00050016', b'1', '2022-05-24 16:40:37.533000', '2022-05-24 16:40:37.533000');
INSERT INTO `sys_serial_number` VALUES (30, 5, 'sys_auth_res', '0013', b'1', '2022-05-24 17:05:39.146000', '2022-05-24 17:05:39.146000');
INSERT INTO `sys_serial_number` VALUES (31, 5, 'sys_auth_res', '00050015', b'1', '2022-05-24 19:51:40.705000', '2022-05-24 19:51:40.705000');
INSERT INTO `sys_serial_number` VALUES (32, 5, 'sys_auth_res', '00050014', b'1', '2022-05-24 19:54:45.206000', '2022-05-24 19:54:45.206000');
INSERT INTO `sys_serial_number` VALUES (33, 11, 'sys_auth_res', '00050013', b'1', '2022-05-24 19:55:45.053000', '2022-05-24 19:55:45.053000');
INSERT INTO `sys_serial_number` VALUES (34, 5, 'sys_auth_res', '00050018', b'1', '2022-05-24 19:59:10.502000', '2022-05-24 19:59:10.502000');
INSERT INTO `sys_serial_number` VALUES (35, 4, 'sys_auth_res', '00050020', b'1', '2022-05-24 20:01:21.967000', '2022-05-24 20:01:21.967000');
INSERT INTO `sys_serial_number` VALUES (36, 5, 'sys_auth_res', '00130002', b'1', '2022-05-24 20:05:31.181000', '2022-05-24 20:05:31.181000');
INSERT INTO `sys_serial_number` VALUES (37, 4, 'sys_auth_res', '00130003', b'1', '2022-05-24 20:21:21.229000', '2022-05-24 20:21:21.229000');
INSERT INTO `sys_serial_number` VALUES (38, 7, 'sys_auth_res', '00130004', b'1', '2022-05-24 20:22:34.630000', '2022-05-24 20:22:34.630000');
INSERT INTO `sys_serial_number` VALUES (39, 4, 'sys_auth_res', '00130005', b'1', '2022-05-25 19:43:01.814000', '2022-05-25 19:43:01.814000');
INSERT INTO `sys_serial_number` VALUES (40, 5, 'sys_auth_res', '0017', b'1', '2022-05-31 21:34:21.598000', '2022-05-31 21:34:21.598000');
INSERT INTO `sys_serial_number` VALUES (41, 7, 'sys_auth_res', '0016', b'1', '2022-05-31 21:40:04.163000', '2022-05-31 21:40:04.163000');
INSERT INTO `sys_serial_number` VALUES (42, 4, 'sys_auth_res', '00050021', b'1', '2022-06-01 19:16:33.029000', '2022-06-01 19:16:33.029000');
INSERT INTO `sys_serial_number` VALUES (43, 2, 'sys_data_dict', '0014', b'1', '2022-06-03 11:18:17.683000', '2022-06-03 11:18:17.683000');
INSERT INTO `sys_serial_number` VALUES (44, 2, 'sys_data_dict', '0015', b'1', '2022-06-03 11:20:17.036000', '2022-06-03 11:20:17.036000');
INSERT INTO `sys_serial_number` VALUES (45, 9, 'sys_data_dict', '0012', b'1', '2022-06-03 18:26:51.617000', '2022-06-03 18:26:51.617000');
INSERT INTO `sys_serial_number` VALUES (46, 2, 'sys_auth_res', '0020', b'1', '2022-06-04 16:19:16.892000', '2022-06-04 16:19:16.892000');
INSERT INTO `sys_serial_number` VALUES (47, 1, 'sys_auth_res', '00200001', b'1', '2022-06-04 16:19:24.855000', '2022-06-04 16:19:24.855000');
INSERT INTO `sys_serial_number` VALUES (48, 1, 'sys_auth_res', '00160007', b'1', '2022-06-04 16:29:48.326000', '2022-06-04 16:29:48.326000');
INSERT INTO `sys_serial_number` VALUES (49, 1, 'sys_auth_res', '00200002', b'1', '2022-06-04 16:30:18.557000', '2022-06-04 16:30:18.557000');
INSERT INTO `sys_serial_number` VALUES (50, 2, 'sys_auth_res', '00060016', b'1', '2022-06-04 17:00:07.781000', '2022-06-04 17:00:07.781000');
INSERT INTO `sys_serial_number` VALUES (51, 2, 'sys_auth_res', '0021', b'1', '2022-06-04 17:14:47.555000', '2022-06-04 17:14:47.555000');
INSERT INTO `sys_serial_number` VALUES (52, 1, 'sys_auth_res', '00210002', b'1', '2022-06-04 17:17:02.954000', '2022-06-04 17:17:02.954000');
INSERT INTO `sys_serial_number` VALUES (53, 1, 'sys_auth_res', '002100020001', b'1', '2022-06-04 17:17:03.016000', '2022-06-04 17:17:03.016000');
INSERT INTO `sys_serial_number` VALUES (54, 1, 'sys_auth_res', '0021000200010001', b'1', '2022-06-04 17:17:03.118000', '2022-06-04 17:17:03.118000');
INSERT INTO `sys_serial_number` VALUES (55, 1, 'sys_auth_res', '00210002000100010001', b'1', '2022-06-04 17:17:03.166000', '2022-06-04 17:17:03.166000');
INSERT INTO `sys_serial_number` VALUES (56, 1, 'sys_auth_res', '00210001', b'1', '2022-06-04 17:22:07.024000', '2022-06-04 17:22:07.024000');
INSERT INTO `sys_serial_number` VALUES (57, 1, 'sys_auth_res', '00060017', b'1', '2022-06-04 17:22:18.723000', '2022-06-04 17:22:18.723000');
INSERT INTO `sys_serial_number` VALUES (58, 1, 'sys_auth_res', '0022', b'1', '2022-06-04 17:22:39.324000', '2022-06-04 17:22:39.324000');
INSERT INTO `sys_serial_number` VALUES (59, 3, 'sys_dept', '0', b'1', '2022-06-04 17:27:03.828000', '2022-06-04 17:27:03.828000');
INSERT INTO `sys_serial_number` VALUES (60, 2, 'sys_dept', '0001', b'1', '2022-06-04 17:27:03.902000', '2022-06-04 17:27:03.902000');
INSERT INTO `sys_serial_number` VALUES (61, 2, 'sys_dept', '0020', b'1', '2022-06-04 17:27:17.039000', '2022-06-04 17:27:17.039000');
INSERT INTO `sys_serial_number` VALUES (62, 2, 'sys_dept', '00200001', b'1', '2022-06-04 17:27:17.087000', '2022-06-04 17:27:17.087000');
INSERT INTO `sys_serial_number` VALUES (63, 3, 'sys_dept', '00010002', b'1', '2022-06-04 17:27:24.635000', '2022-06-04 17:27:24.635000');
INSERT INTO `sys_serial_number` VALUES (64, 2, 'sys_dept', '0002', b'1', '2022-06-04 17:29:16.155000', '2022-06-04 17:29:16.155000');
INSERT INTO `sys_serial_number` VALUES (65, 3, 'sys_dept', '0003', b'1', '2022-06-04 17:31:35.555000', '2022-06-04 17:31:35.555000');
INSERT INTO `sys_serial_number` VALUES (66, 1, 'sys_auth_res', '0023', b'1', '2022-06-04 18:58:31.198000', '2022-06-04 18:58:31.198000');
INSERT INTO `sys_serial_number` VALUES (67, 4, 'sys_auth_res', '00220001', b'1', '2022-06-06 07:42:46.933000', '2022-06-06 07:42:46.933000');
INSERT INTO `sys_serial_number` VALUES (68, 3, 'sys_data_dict', '0017', b'1', '2022-06-06 08:37:38.659000', '2022-06-06 08:37:38.659000');
COMMIT;

-- ----------------------------
-- Table structure for u_auth_res
-- ----------------------------
DROP TABLE IF EXISTS `u_auth_res`;
CREATE TABLE `u_auth_res` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `actionId` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `appType` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `authCheck` bit(1) DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `display` bit(1) NOT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `level` int NOT NULL,
  `menu` bit(1) NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `parentId` bigint NOT NULL,
  `repeatCheck` bit(1) DEFAULT NULL,
  `riskCheck` bit(1) DEFAULT NULL,
  `riskCheckCondition` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int NOT NULL,
  `tplUrl` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `orderNo` int NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `url_appType` (`url`,`appType`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3553 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_auth_res
-- ----------------------------
BEGIN;
INSERT INTO `u_auth_res` VALUES (1, b'1', '2021-07-14 01:40:51.732000', '2022-06-06 09:11:11.540000', '', 'system', b'1', '0006', b'1', ' ', 0, b'0', '系统请求链接', 0, b'0', b'0', NULL, 1, 'front', '/', 0, NULL);
INSERT INTO `u_auth_res` VALUES (3, b'1', '2021-07-14 01:40:51.593000', '2022-06-04 22:17:14.892000', '', 'system', b'0', '00060009', b'1', ' ', 1, b'0', '获取系统数据配置列表', 1, b'0', b'0', NULL, 1, '/system/common/dataConfigList', '/system/common/dataConfigList', 1, NULL);
INSERT INTO `u_auth_res` VALUES (4, b'1', '2021-07-14 01:40:51.608000', '2022-04-18 20:11:22.275000', '', 'system', b'0', '00060008', b'1', NULL, 1, b'0', '获取风控图形验证码', 1, b'0', b'0', NULL, 1, 'system/common/getRiskSmsCode', '/system/common/getRiskSmsCode', 0, NULL);
INSERT INTO `u_auth_res` VALUES (5, b'1', '2021-07-14 01:40:51.718000', '2022-05-25 17:25:50.424000', '', 'system', b'0', '00060007', b'1', ' ', 1, b'0', '文件上传', 1, b'0', b'0', NULL, 1, '/system/common/upload', '/system/common/upload', 0, NULL);
INSERT INTO `u_auth_res` VALUES (6, b'1', '2021-07-14 01:40:51.777000', '2022-05-25 18:05:55.018000', '', 'system', b'0', '00060006', b'1', ' ', 1, b'0', '文件下载', 1, b'0', b'0', NULL, 1, '/system/common/res', '/system/common/res', 0, NULL);
INSERT INTO `u_auth_res` VALUES (7, b'1', '2021-07-14 01:40:51.791000', '2022-04-18 20:10:53.024000', '', 'user', b'0', '00060005', b'1', NULL, 1, b'0', '获取登录用户信息', 1, b'0', b'0', NULL, 1, '/user/user/getLoginUserInfo', '/user/user/getLoginUserInfo', 0, NULL);
INSERT INTO `u_auth_res` VALUES (8, b'1', '2022-03-21 09:09:13.848000', '2022-04-18 20:10:41.833000', '', 'user', b'0', '00060004', b'1', NULL, 1, b'0', '用户注销', 1, b'0', b'0', NULL, 1, 'user/user/logout', '/user/user/logout', 0, NULL);
INSERT INTO `u_auth_res` VALUES (9, b'1', '2022-03-21 09:09:13.871000', '2022-04-18 20:10:31.766000', '', 'user', b'0', '00060003', b'1', NULL, 1, b'0', '用户登录', 1, b'0', b'0', NULL, 1, 'user/user/login', '/user/user/login', 0, NULL);
INSERT INTO `u_auth_res` VALUES (10, b'1', '2021-07-14 01:40:51.577000', '2022-04-18 20:12:01.855000', '', 'user', b'1', '00060010', b'1', NULL, 1, b'0', '根据登录用户获取权限资源', 1, b'0', b'0', NULL, 1, '/user/authRes/getAuthResByCurrentUser', '/user/authRes/getAuthResByCurrentUser', 0, NULL);
INSERT INTO `u_auth_res` VALUES (11, b'1', '2022-03-21 09:09:14.074000', '2022-04-18 20:10:15.226000', '', 'user', b'0', '00060002', b'1', NULL, 1, b'0', '获取短信验证码', 1, b'0', b'0', NULL, 1, 'user/user/getSmsCode', '/user/user/getSmsCode', 0, NULL);
INSERT INTO `u_auth_res` VALUES (2667, b'1', '2022-03-29 10:13:46.623000', '2022-05-27 19:16:18.011000', '', 'system', b'0', '00060001', b'1', ' ', 1, b'0', '获取系统字典选项', 1, b'0', b'0', NULL, 1, '/system/common/dataOptionList', '/system/common/dataOptionList', 0, NULL);
INSERT INTO `u_auth_res` VALUES (3358, b'1', '2022-03-21 09:09:10.560000', '2022-06-04 18:58:31.071000', '', 'system', b'0', '0023', b'1', 'home', 0, b'1', '首页', 0, b'0', b'0', NULL, 1, 'dashboard/Analysis', '/index', 1, '首页，不能删除');
INSERT INTO `u_auth_res` VALUES (3359, b'1', '2022-03-21 09:09:10.560000', '2022-06-04 18:58:57.224000', '', 'system', b'1', '0005', b'1', 'setting', 0, b'1', '系统管理', 0, b'0', b'0', NULL, 1, 'layouts/RouteView', '/system', 5, NULL);
INSERT INTO `u_auth_res` VALUES (3360, b'1', '2022-03-21 09:09:10.560000', '2022-06-01 19:32:57.964000', '', 'system', b'1', '00050013', b'1', 'user', 1, b'1', '用户管理', 3359, b'0', b'0', NULL, 1, 'auth/user/UserList', '/system/user', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3361, b'1', '2022-03-21 09:09:10.560000', '2022-06-03 10:07:46.830000', '', 'system', b'1', '00050020', b'1', 'file-text', 1, b'1', '数据配置', 3359, b'0', b'0', NULL, 1, 'auth/dataConfig/DataConfigList', '/system/dataConfig', 7, NULL);
INSERT INTO `u_auth_res` VALUES (3362, b'1', '2022-03-21 09:09:10.560000', '2022-06-03 10:09:01.158000', '', 'system', b'1', '00050017', b'1', 'menu', 1, b'1', '菜单管理', 3359, b'0', b'0', NULL, 1, 'auth/authRes/AuthResList', '/system/menu', 5, NULL);
INSERT INTO `u_auth_res` VALUES (3363, b'1', '2022-03-21 09:09:10.560000', '2022-06-02 21:53:51.550000', '', 'system', b'1', '00050016', b'1', 'contacts', 1, b'1', '角色管理', 3359, b'0', b'0', NULL, 1, 'auth/role/RoleList', '/system/role', 4, NULL);
INSERT INTO `u_auth_res` VALUES (3364, b'1', '2022-03-21 09:09:10.560000', '2022-05-31 21:03:26.565000', '', 'system', b'1', '00050014', b'1', 'team', 1, b'1', '部门管理', 3359, b'0', b'0', NULL, 1, 'auth/dept/DeptList', '/system/dept', 2, NULL);
INSERT INTO `u_auth_res` VALUES (3365, b'1', '2022-03-21 09:09:10.560000', '2022-06-02 21:53:10.615000', '', 'system', b'1', '00050015', b'1', 'solution', 1, b'1', '职务管理', 3359, b'0', b'0', NULL, 1, 'auth/position/PositionList', '/system/position', 3, NULL);
INSERT INTO `u_auth_res` VALUES (3366, b'1', '2022-03-21 09:09:10.560000', '2022-06-03 10:07:23.562000', '', 'system', b'1', '00050018', b'1', 'file', 1, b'1', '数据字典', 3359, b'0', b'0', NULL, 1, 'auth/dataDict/DataDictList', '/system/dataDict', 6, NULL);
INSERT INTO `u_auth_res` VALUES (3468, b'1', '2022-04-27 11:17:11.227000', '2022-06-06 09:59:55.660000', '', 'demo', b'1', '0022', b'1', 'global', 0, b'1', '示例管理', 0, b'0', b'0', NULL, 1, 'layouts/RouteView', '/demo', 1, '2222');
INSERT INTO `u_auth_res` VALUES (3470, b'1', '2022-04-27 11:59:53.519000', '2022-06-06 08:54:43.689000', '', 'demo', b'1', '00060015', b'1', ' ', 1, b'0', '推送消息', 1, b'0', b'0', NULL, 1, '/system/tools/publishMessage', '/system/tools/publishMessage', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3471, b'1', '2022-05-24 16:33:49.283000', '2022-05-24 19:48:18.174000', '', 'user', b'1', '000500170012', b'1', ' ', 1, b'0', '列表', 3362, b'0', b'0', NULL, 1, 'user/authRes/list', '/user/authRes/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3473, b'1', '2022-05-24 16:37:14.709000', '2022-05-24 17:51:23.440000', '', 'user', b'1', '000500170010', b'1', ' ', 1, b'0', '删除', 3362, b'0', b'0', NULL, 1, '/user/authRes/del', '/user/authRes/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3475, b'1', '2022-05-24 16:38:32.702000', '2022-05-24 16:38:32.702000', '', 'user', b'1', '000500170007', b'1', NULL, 1, b'0', '保存', 3362, b'0', b'0', NULL, 1, '/user/authRes/save', '/user/authRes/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3476, b'1', '2022-05-24 16:40:37.550000', '2022-05-24 16:40:37.550000', '', 'user', b'1', '000500160001', b'1', NULL, 1, b'0', '列表', 3363, b'0', b'0', NULL, 1, '/user/role/list', '/user/role/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3477, b'1', '2022-05-24 16:40:58.651000', '2022-06-03 22:26:07.865000', '', 'user', b'1', '000500160003', b'1', ' ', 1, b'0', '角色授权', 3363, b'0', b'0', NULL, 1, '/user/role/save', '/user/role/saveRoleAuthRes', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3478, b'1', '2022-05-24 17:01:39.777000', '2022-05-24 19:50:04.806000', '', 'user', b'1', '000500170013', b'1', ' ', 1, b'0', '根据角色获取资源', 3362, b'0', b'0', NULL, 1, 'user/authRes/getAuthResTreeVoByRoleId', '/user/authRes/getAuthResTreeVoByRoleId', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3479, b'1', '2022-05-24 17:05:39.165000', '2022-05-25 18:27:54.856000', '', 'code-build', b'1', '00130002', b'1', 'book', 1, b'1', '模板管理', 3469, b'0', b'0', NULL, 1, 'codebuild/template/TemplateList', '/codebuild/template', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3480, b'1', '2022-05-24 17:06:51.222000', '2022-05-25 18:30:39.272000', '', 'code-build', b'1', '00130003', b'1', 'calendar', 1, b'1', '应用管理', 3469, b'0', b'0', NULL, 1, 'codebuild/application/ApplicationList', '/codebuild/application', 2, NULL);
INSERT INTO `u_auth_res` VALUES (3481, b'1', '2022-05-24 17:07:26.741000', '2022-05-25 18:30:48.054000', '', 'code-build', b'1', '00130004', b'1', 'copy', 1, b'1', '实体管理', 3469, b'0', b'0', NULL, 1, 'codebuild/bean/BeanList', '/codebuild/bean', 3, NULL);
INSERT INTO `u_auth_res` VALUES (3482, b'1', '2022-05-24 17:47:25.301000', '2022-05-24 17:47:25.301000', '', 'user', b'1', '000500170009', b'1', NULL, 1, b'0', '列表树', 3362, b'0', b'0', NULL, 1, '/user/authRes/listTree', '/user/authRes/listTree', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3483, b'1', '2022-05-24 19:51:40.749000', '2022-05-24 19:51:40.749000', '', 'user', b'1', '000500150001', b'1', NULL, 1, b'0', '列表', 3365, b'0', b'0', NULL, 1, '/user/position/list', '/user/position/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3484, b'1', '2022-05-24 19:52:34.015000', '2022-05-24 19:52:34.015000', '', 'user', b'1', '000500150002', b'1', NULL, 1, b'0', '保存', 3365, b'0', b'0', NULL, 1, '/user/position/save', '/user/position/save', 2, NULL);
INSERT INTO `u_auth_res` VALUES (3485, b'1', '2022-05-24 19:54:02.157000', '2022-05-24 19:54:02.157000', '', 'user', b'1', '000500150003', b'1', NULL, 1, b'0', '删除', 3365, b'0', b'0', NULL, 1, '/user/position/del', '/user/position/del', 3, NULL);
INSERT INTO `u_auth_res` VALUES (3486, b'1', '2022-05-24 19:54:45.228000', '2022-05-24 19:54:45.228000', '', 'user', b'1', '000500140001', b'1', NULL, 1, b'0', '列表', 3364, b'0', b'0', NULL, 1, '/user/dept/list', '/user/dept/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3487, b'1', '2022-05-24 19:55:06.113000', '2022-05-24 19:55:06.113000', '', 'user', b'1', '000500140002', b'1', NULL, 1, b'0', '保存', 3364, b'0', b'0', NULL, 1, '/user/dept/save', '/user/dept/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3488, b'1', '2022-05-24 19:55:21.862000', '2022-05-24 19:55:21.862000', '', 'user', b'1', '000500140003', b'1', NULL, 1, b'0', '删除', 3364, b'0', b'0', NULL, 1, '/user/dept/del', '/user/dept/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3489, b'1', '2022-05-24 19:55:45.068000', '2022-05-24 19:57:03.702000', '', 'user', b'1', '000500130003', b'1', ' ', 1, b'0', '列表', 3360, b'0', b'0', NULL, 1, '/user/user/list', '/user/user/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3491, b'1', '2022-05-24 19:57:43.806000', '2022-05-24 19:57:43.806000', '', 'user', b'1', '000500130004', b'1', NULL, 1, b'0', '保存', 3360, b'0', b'0', NULL, 1, '/user/user/save', '/user/user/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3492, b'1', '2022-05-24 19:58:16.842000', '2022-05-24 19:58:16.842000', '', 'user', b'1', '000500130005', b'1', NULL, 1, b'0', '删除', 3360, b'0', b'0', NULL, 1, '/user/user/del', '/user/user/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3493, b'1', '2022-05-24 19:59:10.531000', '2022-05-24 19:59:10.531000', '', 'system', b'1', '000500180001', b'1', NULL, 1, b'0', '列表', 3366, b'0', b'0', NULL, 1, '/system/dataDict/list', '/system/dataDict/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3494, b'1', '2022-05-24 19:59:37.176000', '2022-05-24 19:59:37.176000', '', 'system', b'1', '000500180002', b'1', NULL, 1, b'0', '列表树', 3366, b'0', b'0', NULL, 1, '/system/dataDict/listTree', '/system/dataDict/listTree', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3495, b'1', '2022-05-24 20:00:18.760000', '2022-05-24 20:00:18.760000', '', 'system', b'1', '000500180003', b'1', NULL, 1, b'0', '保存', 3366, b'0', b'0', NULL, 1, '/system/dataDict/save', '/system/dataDict/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3496, b'1', '2022-05-24 20:00:44.153000', '2022-05-24 20:00:44.153000', '', 'system', b'1', '000500180004', b'1', NULL, 1, b'0', '删除', 3366, b'0', b'0', NULL, 1, '/system/dataDict/del', '/system/dataDict/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3497, b'1', '2022-05-24 20:01:21.985000', '2022-05-24 20:01:21.985000', '', 'system', b'1', '000500200001', b'1', NULL, 1, b'0', '列表', 3361, b'0', b'0', NULL, 1, '/system/dataConfig/list', '/system/dataConfig/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3498, b'1', '2022-05-24 20:01:40.715000', '2022-05-24 20:01:40.715000', '', 'system', b'1', '000500200002', b'1', NULL, 1, b'0', '保存', 3361, b'0', b'0', NULL, 1, '/system/dataConfig/save', '/system/dataConfig/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3499, b'1', '2022-05-24 20:01:56.892000', '2022-05-24 20:01:56.892000', '', 'system', b'1', '000500200003', b'1', NULL, 1, b'0', '删除', 3361, b'0', b'0', NULL, 1, '/system/dataConfig/del', '/system/dataConfig/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3500, b'1', '2022-05-24 20:05:31.208000', '2022-05-24 20:05:31.208000', '', 'code-build', b'1', '001300020001', b'1', NULL, 1, b'0', '列表', 3479, b'0', b'0', NULL, 1, '/codebuild/template/list', '/codebuild/template/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3501, b'1', '2022-05-24 20:05:49.368000', '2022-05-24 20:05:49.368000', '', 'code-build', b'1', '001300020002', b'1', NULL, 1, b'0', '保存', 3479, b'0', b'0', NULL, 1, '/codebuild/template/save', '/codebuild/template/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3502, b'1', '2022-05-24 20:06:11.595000', '2022-05-24 20:06:11.595000', '', 'code-build', b'1', '001300020003', b'1', NULL, 1, b'0', '删除', 3479, b'0', b'0', NULL, 1, '/codebuild/template/del', '/codebuild/template/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3503, b'1', '2022-05-24 20:21:21.286000', '2022-05-24 20:21:21.286000', '', 'code-build', b'1', '001300030001', b'1', NULL, 1, b'0', '列表', 3480, b'0', b'0', NULL, 1, '/codebuild/application/list', '/codebuild/application/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3504, b'1', '2022-05-24 20:21:45.996000', '2022-05-24 20:21:45.996000', '', 'code-build', b'1', '001300030002', b'1', NULL, 1, b'0', '保存', 3480, b'0', b'0', NULL, 1, '/codebuild/application/save', '/codebuild/application/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3505, b'1', '2022-05-24 20:22:05.977000', '2022-05-24 20:22:05.977000', '', 'code-build', b'1', '001300030003', b'1', NULL, 1, b'0', '删除', 3480, b'0', b'0', NULL, 1, '/codebuild/application/del', '/codebuild/application/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3506, b'1', '2022-05-24 20:22:34.643000', '2022-05-24 20:22:34.643000', '', 'code-build', b'1', '001300040001', b'1', NULL, 1, b'0', '列表', 3481, b'0', b'0', NULL, 1, '/codebuild//codebuild/bean/list/list', '/codebuild/bean/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3507, b'1', '2022-05-24 20:22:51.078000', '2022-05-24 20:22:51.078000', '', 'code-build', b'1', '001300040002', b'1', NULL, 1, b'0', '保存', 3481, b'0', b'0', NULL, 1, '/codebuild/bean/save', '/codebuild/bean/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3508, b'1', '2022-05-24 20:23:07.996000', '2022-05-24 20:23:07.996000', '', 'code-build', b'1', '001300040003', b'1', NULL, 1, b'0', '删除', 3481, b'0', b'0', NULL, 1, '/codebuild/bean/del', '/codebuild/bean/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3509, b'1', '2022-05-24 20:24:08.277000', '2022-05-24 20:24:08.277000', '', 'code-build', b'1', '001300040004', b'1', NULL, 1, b'0', '单个属性保存', 3481, b'0', b'0', NULL, 1, '/codebuild/property/save', '/codebuild/property/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3510, b'1', '2022-05-24 20:24:55.924000', '2022-05-24 20:24:55.924000', '', 'code-build', b'1', '001300040005', b'1', NULL, 1, b'0', '单个属性删除', 3481, b'0', b'0', NULL, 1, '/codebuild/property/del', '/codebuild/property/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3511, b'1', '2022-05-25 19:42:27.942000', '2022-05-25 19:42:27.942000', '', 'code-build', b'1', '00130005', b'1', 'hdd', 1, b'1', '数据源', 3469, b'0', b'0', NULL, 1, 'codebuild/dataSource/DataSourceList', '/codebuild/dataSource', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3512, b'1', '2022-05-25 19:43:01.826000', '2022-05-25 19:43:01.826000', '', 'code-build', b'1', '001300050001', b'1', NULL, 1, b'0', '列表', 3511, b'0', b'0', NULL, 1, '/codebuild/dataSource/list', '/codebuild/dataSource/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3513, b'1', '2022-05-25 19:43:26.343000', '2022-05-25 19:43:26.343000', '', 'code-build', b'1', '001300050002', b'1', NULL, 1, b'0', '所有列表', 3511, b'0', b'0', NULL, 1, '/codebuild/dataSource/listAll', '/codebuild/dataSource/listAll', 2, NULL);
INSERT INTO `u_auth_res` VALUES (3514, b'1', '2022-05-25 19:43:41.988000', '2022-05-25 19:43:41.988000', '', 'code-build', b'1', '001300050003', b'1', NULL, 1, b'0', '保存', 3511, b'0', b'0', NULL, 1, '/codebuild/dataSource/save', '/codebuild/dataSource/save', 3, NULL);
INSERT INTO `u_auth_res` VALUES (3515, b'1', '2022-05-25 19:43:58.847000', '2022-05-25 19:43:58.847000', '', 'code-build', b'1', '001300050004', b'1', NULL, 1, b'0', '删除', 3511, b'0', b'0', NULL, 1, '/codebuild/dataSource/del', '/codebuild/dataSource/del', 4, NULL);
INSERT INTO `u_auth_res` VALUES (3517, b'1', '2022-05-25 19:44:51.521000', '2022-05-25 19:44:51.521000', '', 'code-build', b'1', '001300020005', b'1', NULL, 1, b'0', '所有列表', 3479, b'0', b'0', NULL, 1, '/codebuild/template/listAll', '/codebuild/template/listAll', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3518, b'1', '2022-05-25 22:09:39.427000', '2022-05-25 22:09:39.427000', '', 'code-build', b'1', '001300030004', b'1', NULL, 1, b'0', '所有列表', 3480, b'0', b'0', NULL, 1, '/codebuild/application/listAll', '/codebuild/application/listAll', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3519, b'1', '2022-05-26 21:56:13.324000', '2022-05-26 21:56:13.324000', '', 'code-build', b'1', '001300040006', b'1', NULL, 1, b'0', '所有属性列表', 3481, b'0', b'0', NULL, 1, '/codebuild/property/listAll', '/codebuild/property/listAll', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3520, b'1', '2022-05-27 19:59:14.324000', '2022-05-27 19:59:14.324000', '', 'code-build', b'1', '001300040007', b'1', NULL, 1, b'0', '生成源码', 3481, b'0', b'0', NULL, 1, '/codebuild/bean/build', '/codebuild/bean/build', 7, NULL);
INSERT INTO `u_auth_res` VALUES (3521, b'1', '2022-05-31 20:02:10.649000', '2022-06-01 19:32:40.188000', '', 'system', b'1', '00050021', b'1', 'user', 1, b'1', '员工管理', 3359, b'0', b'0', NULL, 1, 'auth/employee/EmployeeList', '/system/employee', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3522, b'1', '2022-05-31 20:22:22.805000', '2022-05-31 20:22:22.805000', '', 'user', b'1', '000500140004', b'1', NULL, 1, b'0', '列表树', 3364, b'0', b'0', NULL, 1, '/user/dept/listTree', '/user/dept/listTree', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3523, b'1', '2022-06-01 17:12:35.466000', '2022-06-01 17:12:35.466000', '', 'user', b'1', '000500150004', b'1', NULL, 1, b'0', '所有列表', 3365, b'0', b'0', NULL, 1, '/user/position/listAll', '/user/position/listAll', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3524, b'1', '2022-06-01 17:12:53.718000', '2022-06-01 17:12:53.718000', '', 'user', b'1', '000500160004', b'1', NULL, 1, b'0', '所有角色', 3363, b'0', b'0', NULL, 1, '/user/role/listAll', '/user/role/listAll', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3526, b'1', '2022-06-01 18:25:21.455000', '2022-06-01 18:25:21.455000', '', 'user', b'1', '000500130007', b'1', NULL, 1, b'0', '修改', 3360, b'0', b'0', NULL, 1, '/user/user/update', '/user/user/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3527, b'1', '2022-06-01 18:26:32.280000', '2022-06-01 18:26:32.280000', '', 'user', b'1', '000500140005', b'1', NULL, 1, b'0', '修改', 3364, b'0', b'0', NULL, 1, '/user/dept/update', '/user/dept/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3528, b'1', '2022-06-01 18:27:00.908000', '2022-06-01 18:27:00.908000', '', 'user', b'1', '000500150005', b'1', NULL, 1, b'0', '修改', 3365, b'0', b'0', NULL, 1, '/user/position/update', '/user/position/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3529, b'1', '2022-06-01 18:27:24.587000', '2022-06-01 18:27:24.587000', '', 'user', b'1', '000500160005', b'1', NULL, 1, b'0', '修改', 3363, b'0', b'0', NULL, 1, '/user/role/update', '/user/role/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3530, b'1', '2022-06-01 18:27:46.911000', '2022-06-01 18:27:46.911000', '', 'user', b'1', '000500170014', b'1', NULL, 1, b'0', '修改', 3362, b'0', b'0', NULL, 1, '/user/authRes/update', '/user/authRes/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3531, b'1', '2022-06-01 18:28:11.741000', '2022-06-01 18:28:11.741000', '', 'system', b'1', '000500180005', b'1', NULL, 1, b'0', '修改', 3366, b'0', b'0', NULL, 1, '/system/dataDict/update', '/system/dataDict/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3532, b'1', '2022-06-01 18:28:32.235000', '2022-06-03 21:56:54.440000', '', 'system', b'1', '000500200004', b'1', ' ', 1, b'0', '修改', 3361, b'0', b'0', NULL, 1, '/system/dataConfig/update', '/system/dataConfig/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3533, b'1', '2022-06-01 19:16:33.054000', '2022-06-01 19:16:33.054000', '', 'user', b'1', '000500210001', b'1', NULL, 1, b'0', '列表', 3521, b'0', b'0', NULL, 1, '/user/employee/list', '/user/employee/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3534, b'1', '2022-06-01 19:16:51.859000', '2022-06-01 19:16:51.859000', '', 'user', b'1', '000500210002', b'1', NULL, 1, b'0', '保存', 3521, b'0', b'0', NULL, 1, '/user/employee/save', '/user/employee/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3535, b'1', '2022-06-01 19:17:08.881000', '2022-06-01 19:17:08.881000', '', 'user', b'1', '000500210003', b'1', NULL, 1, b'0', '修改', 3521, b'0', b'0', NULL, 1, '/user/employee/update', '/user/employee/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3536, b'1', '2022-06-01 19:17:22.607000', '2022-06-01 19:17:22.607000', '', 'user', b'1', '000500210004', b'1', NULL, 1, b'0', '删除', 3521, b'0', b'0', NULL, 1, '/user/employee/del', '/user/employee/del', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3537, b'1', '2022-06-02 11:45:43.461000', '2022-06-02 11:45:43.461000', '', 'user', b'1', '000500130008', b'1', NULL, 1, b'0', '重置密码', 3360, b'0', b'0', NULL, 1, '/user/user/resetPwd', '/user/user/resetPwd', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3538, b'1', '2022-06-02 11:46:07.460000', '2022-06-02 11:46:07.460000', '', 'user', b'1', '000500130009', b'1', NULL, 1, b'0', '用户自己修改密码', 3360, b'0', b'0', NULL, 1, '/user/user/updatePwd', '/user/user/updatePwd', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3539, b'1', '2022-06-02 11:46:33.284000', '2022-06-02 11:46:33.284000', '', 'user', b'1', '000500130010', b'1', NULL, 1, b'0', '冻结', 3360, b'0', b'0', NULL, 1, '/user/user/freeze', '/user/user/freeze', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3540, b'1', '2022-06-02 11:46:56.774000', '2022-06-02 11:46:56.774000', '', 'user', b'1', '000500130011', b'1', NULL, 1, b'0', '解冻', 3360, b'0', b'0', NULL, 1, '/user/user/unFreeze', '/user/user/unFreeze', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3542, b'1', '2022-06-03 22:26:44.090000', '2022-06-03 22:26:44.090000', '', 'user', b'1', '000500160007', b'1', NULL, 1, b'0', '保存', 3363, b'0', b'0', NULL, 1, '/user/role/save', '/user/role/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3543, b'1', '2022-06-04 15:45:03.619000', '2022-06-06 10:00:48.040000', '', 'demo', b'1', '00220001', b'1', 'tablet', 1, b'1', '示例', 3468, b'0', b'0', NULL, 1, 'demo/demo/DemoList', '/demo/demo', 1, 'demo');
INSERT INTO `u_auth_res` VALUES (3545, b'1', '2022-06-04 22:18:59.056000', '2022-06-04 22:18:59.056000', '', 'user', b'0', '00060019', b'1', NULL, 1, b'0', '用户注册', 1, b'0', b'0', NULL, 1, '/user/user/register', '/user/user/register', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3546, b'1', '2022-06-04 22:32:46.555000', '2022-06-04 22:32:46.555000', '', 'user', b'0', '00060020', b'1', NULL, 1, b'0', '根据短信验证码修改忘记密码', 1, b'0', b'0', NULL, 1, '/user/user/updateForgetLoginPwdBySmsCode', '/user/user/updateForgetLoginPwdBySmsCode', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3547, b'1', '2022-06-04 23:17:19.574000', '2022-06-04 23:17:19.574000', '', 'user', b'0', '00060021', b'1', NULL, 1, b'0', '注册检测用户是否唯一', 1, b'0', b'0', NULL, 1, '/user/user/checkUserUnique', '/user/user/checkUserUnique', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3548, b'1', '2022-06-05 14:32:49.711000', '2022-06-05 14:32:49.711000', '', 'user', b'0', '00060022', b'1', NULL, 1, b'0', '手机验证码登录', 1, b'0', b'0', NULL, 1, '/user/user/loginByMobile', '/user/user/loginByMobile', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3549, b'1', '2022-06-06 07:42:46.984000', '2022-06-06 09:11:49.142000', '', 'demo', b'1', '002200010001', b'1', ' ', 1, b'0', '列表', 3543, b'0', b'0', NULL, 1, '/demo/demo/list', '/demo/demo/list', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3550, b'1', '2022-06-06 07:43:16.347000', '2022-06-06 09:11:56.381000', '', 'demo', b'1', '002200010002', b'1', ' ', 1, b'0', '保存', 3543, b'0', b'0', NULL, 1, '/demo/demo/save', '/demo/demo/save', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3551, b'1', '2022-06-06 07:43:33.987000', '2022-06-06 09:12:02.411000', '', 'demo', b'1', '002200010003', b'1', ' ', 1, b'0', '修改', 3543, b'0', b'0', NULL, 1, '/demo/demo/update', '/demo/demo/update', 1, NULL);
INSERT INTO `u_auth_res` VALUES (3552, b'1', '2022-06-06 07:43:57.544000', '2022-06-06 09:12:09.490000', '', 'demo', b'1', '002200010004', b'1', ' ', 1, b'0', '删除', 3543, b'0', b'0', NULL, 1, '/demo/demo/del', '/demo/demo/del', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for u_dept
-- ----------------------------
DROP TABLE IF EXISTS `u_dept`;
CREATE TABLE `u_dept` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `parentId` bigint NOT NULL,
  `orderNo` int NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_pruj1nad6wtsor0ll26s8u90g` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_dept
-- ----------------------------
BEGIN;
INSERT INTO `u_dept` VALUES (1, b'1', '2022-04-13 08:17:31.000000', '2022-06-04 17:31:35.511000', '北京总部', 0, 1, '北京总部', '0003');
INSERT INTO `u_dept` VALUES (2, b'1', '2022-05-31 21:32:50.088000', '2022-06-04 17:29:16.127000', '杭州分公司', 0, 1, '杭州分公司1', '0002');
INSERT INTO `u_dept` VALUES (3, b'1', '2022-05-31 21:34:21.614000', '2022-06-04 17:31:35.569000', '总经办', 1, 1, '总经办', '00030001');
INSERT INTO `u_dept` VALUES (4, b'1', '2022-05-31 21:34:38.854000', '2022-06-04 17:31:35.606000', '财务部', 1, 2, '财务部', '00030002');
INSERT INTO `u_dept` VALUES (5, b'1', '2022-05-31 21:38:38.788000', '2022-05-31 21:38:38.788000', '技术部', 1, 3, '技术部', '00030003');
INSERT INTO `u_dept` VALUES (6, b'1', '2022-05-31 21:40:04.210000', '2022-06-04 17:29:16.171000', '技术部', 2, 1, '技术部', '00020001');
INSERT INTO `u_dept` VALUES (7, b'1', '2022-05-31 21:40:15.245000', '2022-06-04 17:29:16.201000', '市场部', 2, 2, '市场部', '00020002');
INSERT INTO `u_dept` VALUES (9, b'1', '2022-06-01 12:06:12.705000', '2022-06-01 12:06:12.705000', '公关部', 1, 5, '公关部', '00030004');
INSERT INTO `u_dept` VALUES (10, b'1', '2022-06-04 16:19:06.079000', '2022-06-04 16:19:06.079000', 'test', 0, 1, '1', '0020');
INSERT INTO `u_dept` VALUES (11, b'1', '2022-06-04 16:19:16.905000', '2022-06-04 17:27:03.908000', 'test1', 12, 1, 'test1', '00010001');
INSERT INTO `u_dept` VALUES (12, b'1', '2022-06-04 16:19:24.873000', '2022-06-04 17:27:03.884000', 'test2', 0, 2, 'test2', '0001');
INSERT INTO `u_dept` VALUES (13, b'1', '2022-06-07 21:54:04.214000', '2022-06-07 21:54:04.214000', 'test2', 10, 2, '2222', '00200002');
COMMIT;

-- ----------------------------
-- Table structure for u_employee
-- ----------------------------
DROP TABLE IF EXISTS `u_employee`;
CREATE TABLE `u_employee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `userId` bigint NOT NULL,
  `jobNo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKpu8m6wye4jaehpgpu75y81mll` (`userId`) USING BTREE,
  CONSTRAINT `FKpu8m6wye4jaehpgpu75y81mll` FOREIGN KEY (`userId`) REFERENCES `u_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_employee
-- ----------------------------
BEGIN;
INSERT INTO `u_employee` VALUES (2, b'1', '2022-06-01 21:32:11.613000', '2022-06-01 22:11:04.582000', '1', 15, '12342', '43242');
INSERT INTO `u_employee` VALUES (3, b'1', '2022-06-01 21:49:44.990000', '2022-06-01 21:49:44.990000', '2', 16, '111', '32');
INSERT INTO `u_employee` VALUES (4, b'1', '2022-06-02 12:41:02.237000', '2022-06-05 19:10:43.868000', '5', 17, '5', '5');
COMMIT;

-- ----------------------------
-- Table structure for u_outer_user
-- ----------------------------
DROP TABLE IF EXISTS `u_outer_user`;
CREATE TABLE `u_outer_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `bindType` int NOT NULL,
  `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `openId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` int NOT NULL,
  `userId` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for u_position
-- ----------------------------
DROP TABLE IF EXISTS `u_position`;
CREATE TABLE `u_position` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `orderNo` int NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_position
-- ----------------------------
BEGIN;
INSERT INTO `u_position` VALUES (1, b'1', '2022-04-13 08:17:55.000000', '2022-06-03 10:40:44.881000', '总经理', 1, '总经理');
INSERT INTO `u_position` VALUES (2, b'1', '2022-04-20 10:18:12.016000', '2022-06-03 10:41:18.893000', '技术专家', 2, '技术专家');
INSERT INTO `u_position` VALUES (3, b'1', '2022-06-03 10:24:10.192000', '2022-06-03 10:24:10.192000', '技术经理', 3, '技术经理');
INSERT INTO `u_position` VALUES (4, b'1', '2022-06-03 10:41:42.619000', '2022-06-03 10:41:42.619000', 'CEO', 4, '首席执行官');
INSERT INTO `u_position` VALUES (5, b'1', '2022-06-03 10:42:02.316000', '2022-06-03 10:42:02.316000', '客服经理', 5, '客服经理');
INSERT INTO `u_position` VALUES (6, b'1', '2022-06-03 10:42:20.503000', '2022-06-03 10:42:20.503000', '市场总监', 6, '市场总监');
COMMIT;

-- ----------------------------
-- Table structure for u_role
-- ----------------------------
DROP TABLE IF EXISTS `u_role`;
CREATE TABLE `u_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_role
-- ----------------------------
BEGIN;
INSERT INTO `u_role` VALUES (1, b'1', '2022-03-18 16:51:32.000000', '2022-06-07 12:18:59.932000', 'admin', '最高权限管理员');
INSERT INTO `u_role` VALUES (2, b'1', '2022-04-20 12:42:03.731000', '2022-06-06 09:56:42.006000', '普通员工', '普通员工');
INSERT INTO `u_role` VALUES (3, b'1', '2022-06-03 22:33:15.944000', '2022-06-06 09:56:47.287000', '财务专员', '财务专员');
COMMIT;

-- ----------------------------
-- Table structure for u_role_auth_res
-- ----------------------------
DROP TABLE IF EXISTS `u_role_auth_res`;
CREATE TABLE `u_role_auth_res` (
  `roleId` bigint NOT NULL,
  `authResId` bigint NOT NULL,
  UNIQUE KEY `roleId_authResId` (`authResId`,`roleId`) USING BTREE,
  KEY `FKd1nw27l5j6dgfd04qqwfrtsrn` (`roleId`) USING BTREE,
  CONSTRAINT `FKd1nw27l5j6dgfd04qqwfrtsrn` FOREIGN KEY (`roleId`) REFERENCES `u_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKjfcmbvv2o169e9f0mswv1hjyu` FOREIGN KEY (`authResId`) REFERENCES `u_auth_res` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_role_auth_res
-- ----------------------------
BEGIN;
INSERT INTO `u_role_auth_res` VALUES (1, 1);
INSERT INTO `u_role_auth_res` VALUES (1, 3);
INSERT INTO `u_role_auth_res` VALUES (1, 4);
INSERT INTO `u_role_auth_res` VALUES (1, 5);
INSERT INTO `u_role_auth_res` VALUES (1, 6);
INSERT INTO `u_role_auth_res` VALUES (1, 7);
INSERT INTO `u_role_auth_res` VALUES (1, 8);
INSERT INTO `u_role_auth_res` VALUES (1, 9);
INSERT INTO `u_role_auth_res` VALUES (1, 10);
INSERT INTO `u_role_auth_res` VALUES (1, 11);
INSERT INTO `u_role_auth_res` VALUES (1, 2667);
INSERT INTO `u_role_auth_res` VALUES (1, 3358);
INSERT INTO `u_role_auth_res` VALUES (1, 3359);
INSERT INTO `u_role_auth_res` VALUES (1, 3360);
INSERT INTO `u_role_auth_res` VALUES (1, 3361);
INSERT INTO `u_role_auth_res` VALUES (1, 3362);
INSERT INTO `u_role_auth_res` VALUES (1, 3363);
INSERT INTO `u_role_auth_res` VALUES (1, 3364);
INSERT INTO `u_role_auth_res` VALUES (1, 3365);
INSERT INTO `u_role_auth_res` VALUES (1, 3366);
INSERT INTO `u_role_auth_res` VALUES (1, 3468);
INSERT INTO `u_role_auth_res` VALUES (1, 3470);
INSERT INTO `u_role_auth_res` VALUES (1, 3471);
INSERT INTO `u_role_auth_res` VALUES (1, 3473);
INSERT INTO `u_role_auth_res` VALUES (1, 3475);
INSERT INTO `u_role_auth_res` VALUES (1, 3476);
INSERT INTO `u_role_auth_res` VALUES (1, 3477);
INSERT INTO `u_role_auth_res` VALUES (1, 3478);
INSERT INTO `u_role_auth_res` VALUES (1, 3482);
INSERT INTO `u_role_auth_res` VALUES (1, 3483);
INSERT INTO `u_role_auth_res` VALUES (1, 3484);
INSERT INTO `u_role_auth_res` VALUES (1, 3485);
INSERT INTO `u_role_auth_res` VALUES (1, 3486);
INSERT INTO `u_role_auth_res` VALUES (1, 3487);
INSERT INTO `u_role_auth_res` VALUES (1, 3488);
INSERT INTO `u_role_auth_res` VALUES (1, 3489);
INSERT INTO `u_role_auth_res` VALUES (1, 3491);
INSERT INTO `u_role_auth_res` VALUES (1, 3492);
INSERT INTO `u_role_auth_res` VALUES (1, 3493);
INSERT INTO `u_role_auth_res` VALUES (1, 3494);
INSERT INTO `u_role_auth_res` VALUES (1, 3495);
INSERT INTO `u_role_auth_res` VALUES (1, 3496);
INSERT INTO `u_role_auth_res` VALUES (1, 3497);
INSERT INTO `u_role_auth_res` VALUES (1, 3498);
INSERT INTO `u_role_auth_res` VALUES (1, 3499);
INSERT INTO `u_role_auth_res` VALUES (1, 3521);
INSERT INTO `u_role_auth_res` VALUES (1, 3522);
INSERT INTO `u_role_auth_res` VALUES (1, 3523);
INSERT INTO `u_role_auth_res` VALUES (1, 3524);
INSERT INTO `u_role_auth_res` VALUES (1, 3526);
INSERT INTO `u_role_auth_res` VALUES (1, 3527);
INSERT INTO `u_role_auth_res` VALUES (1, 3528);
INSERT INTO `u_role_auth_res` VALUES (1, 3529);
INSERT INTO `u_role_auth_res` VALUES (1, 3530);
INSERT INTO `u_role_auth_res` VALUES (1, 3531);
INSERT INTO `u_role_auth_res` VALUES (1, 3532);
INSERT INTO `u_role_auth_res` VALUES (1, 3533);
INSERT INTO `u_role_auth_res` VALUES (1, 3534);
INSERT INTO `u_role_auth_res` VALUES (1, 3535);
INSERT INTO `u_role_auth_res` VALUES (1, 3536);
INSERT INTO `u_role_auth_res` VALUES (1, 3537);
INSERT INTO `u_role_auth_res` VALUES (1, 3538);
INSERT INTO `u_role_auth_res` VALUES (1, 3539);
INSERT INTO `u_role_auth_res` VALUES (1, 3540);
INSERT INTO `u_role_auth_res` VALUES (1, 3542);
INSERT INTO `u_role_auth_res` VALUES (1, 3543);
INSERT INTO `u_role_auth_res` VALUES (1, 3545);
INSERT INTO `u_role_auth_res` VALUES (1, 3546);
INSERT INTO `u_role_auth_res` VALUES (1, 3547);
INSERT INTO `u_role_auth_res` VALUES (1, 3548);
INSERT INTO `u_role_auth_res` VALUES (1, 3549);
INSERT INTO `u_role_auth_res` VALUES (1, 3550);
INSERT INTO `u_role_auth_res` VALUES (1, 3551);
INSERT INTO `u_role_auth_res` VALUES (1, 3552);
INSERT INTO `u_role_auth_res` VALUES (2, 3358);
INSERT INTO `u_role_auth_res` VALUES (2, 3475);
INSERT INTO `u_role_auth_res` VALUES (2, 3476);
INSERT INTO `u_role_auth_res` VALUES (3, 3358);
INSERT INTO `u_role_auth_res` VALUES (3, 3360);
INSERT INTO `u_role_auth_res` VALUES (3, 3468);
INSERT INTO `u_role_auth_res` VALUES (3, 3489);
INSERT INTO `u_role_auth_res` VALUES (3, 3491);
INSERT INTO `u_role_auth_res` VALUES (3, 3492);
INSERT INTO `u_role_auth_res` VALUES (3, 3526);
INSERT INTO `u_role_auth_res` VALUES (3, 3537);
INSERT INTO `u_role_auth_res` VALUES (3, 3538);
INSERT INTO `u_role_auth_res` VALUES (3, 3539);
INSERT INTO `u_role_auth_res` VALUES (3, 3540);
INSERT INTO `u_role_auth_res` VALUES (3, 3543);
INSERT INTO `u_role_auth_res` VALUES (3, 3549);
INSERT INTO `u_role_auth_res` VALUES (3, 3550);
INSERT INTO `u_role_auth_res` VALUES (3, 3551);
INSERT INTO `u_role_auth_res` VALUES (3, 3552);
COMMIT;

-- ----------------------------
-- Table structure for u_user
-- ----------------------------
DROP TABLE IF EXISTS `u_user`;
CREATE TABLE `u_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `delState` bit(1) NOT NULL DEFAULT b'1' COMMENT '数据状态（0 不存在，1 存在）',
  `gmtCreate` datetime(6) DEFAULT NULL COMMENT '数据创建时间',
  `gmtModified` datetime(6) NOT NULL COMMENT '数据最后修改时间',
  `accountNo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `address` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `areaCode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `birthday` datetime(6) DEFAULT NULL,
  `career` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `desc` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `gender` int DEFAULT NULL,
  `inviteCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `local` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `message` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `otherUserId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `payPwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `pwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `shareInviteCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int NOT NULL,
  `type` int NOT NULL,
  `userName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `servicePayFeeRate` decimal(6,5) DEFAULT NULL,
  `serviceWithdrawFeeRate` decimal(6,5) DEFAULT NULL,
  `deptId` bigint DEFAULT NULL,
  `positionId` bigint DEFAULT NULL,
  `wechat` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_account_index` (`type`,`accountNo`) USING BTREE,
  KEY `FKbt88ww5h3hep8ds3f2lopokg4` (`deptId`) USING BTREE,
  KEY `FKfw3unftxfbfj0jycr4mr4owlp` (`positionId`) USING BTREE,
  CONSTRAINT `FKbt88ww5h3hep8ds3f2lopokg4` FOREIGN KEY (`deptId`) REFERENCES `u_dept` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKfw3unftxfbfj0jycr4mr4owlp` FOREIGN KEY (`positionId`) REFERENCES `u_position` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_user
-- ----------------------------
BEGIN;
INSERT INTO `u_user` VALUES (1, b'1', '2022-04-10 18:20:55.000000', '2022-06-07 23:23:55.191000', 'admin', '111', '86', 'https://demo-platform.usefullc.com/system/common/res/system/20220607/c18b07dc-4eb8-4423-afb0-4f3fa7c23724.jpg', NULL, NULL, '1', '1', 1, NULL, NULL, '1', '15267164682', 'Sampson', NULL, NULL, 'BC6EB6C1288C2AD0CF2F238DE6E62AEA', NULL, 1, 1, '星空', NULL, NULL, 5, 1, NULL);
INSERT INTO `u_user` VALUES (2, b'1', '2022-04-24 10:49:30.302000', '2022-06-02 14:40:21.441418', 'test2', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/5d369fde-f7c5-481a-afa1-5ee11bc6719f.png', '2022-04-24 10:28:02.635000', NULL, NULL, '2', 1, NULL, NULL, NULL, '1', 'test2', NULL, NULL, '077F20548C7A3C524D4CE0D88EB898C2', NULL, 2, 1, '测试2', NULL, NULL, 2, 1, NULL);
INSERT INTO `u_user` VALUES (4, b'1', '2022-04-25 17:45:18.536000', '2022-06-02 14:40:21.441418', 'test3', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-04-25 17:44:39.827000', NULL, NULL, '1', 1, NULL, NULL, NULL, '1', 'test3', NULL, NULL, '077F20548C7A3C524D4CE0D88EB898C2', NULL, 2, 1, 'ceshi3', NULL, NULL, 3, 2, NULL);
INSERT INTO `u_user` VALUES (5, b'1', '2022-04-26 15:22:11.308000', '2022-04-26 15:22:11.308000', 'test4', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/191f1957-74ab-47aa-bae1-95cf00d45d72.png', '2022-04-05 15:03:09.051000', NULL, NULL, '1', 1, NULL, NULL, NULL, '1', 'test4', NULL, NULL, 'BC6EB6C1288C2AD0CF2F238DE6E62AEA', NULL, 1, 1, 'ceshi4', NULL, NULL, 3, 2, NULL);
INSERT INTO `u_user` VALUES (6, b'1', '2022-06-01 17:28:28.221000', '2022-06-01 17:28:28.221000', 'test5', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220607/85d47945-3f66-4b48-b07f-8b33b7372f30.jpg', '2022-06-09 17:26:53.614000', NULL, NULL, '1', 0, NULL, NULL, NULL, '2', 'test5', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, 'ceshi1', NULL, NULL, 6, 2, NULL);
INSERT INTO `u_user` VALUES (7, b'1', '2022-06-01 17:58:51.734000', '2022-06-01 17:58:51.734000', 'test6', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-06-23 17:58:29.136000', NULL, NULL, '1', 0, NULL, NULL, NULL, '1', 'test6', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '1', NULL, NULL, 5, 1, NULL);
INSERT INTO `u_user` VALUES (8, b'1', '2022-06-01 18:12:14.218000', '2022-06-01 18:12:14.218000', 'test7', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/5d369fde-f7c5-481a-afa1-5ee11bc6719f.png', '2022-06-15 18:11:56.361000', NULL, NULL, '1', 1, NULL, NULL, NULL, '7', 'test7', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '2', NULL, NULL, 4, 1, NULL);
INSERT INTO `u_user` VALUES (10, b'1', '2022-06-01 18:14:07.089000', '2022-06-01 18:14:07.089000', 'test8', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-06-15 18:11:56.361000', NULL, NULL, '1', 1, NULL, NULL, NULL, '7', 'test8', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '2', NULL, NULL, 4, 1, NULL);
INSERT INTO `u_user` VALUES (11, b'1', '2022-06-01 18:14:42.401000', '2022-06-01 18:14:42.401000', 'test9', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/191f1957-74ab-47aa-bae1-95cf00d45d72.png', '2022-06-15 18:11:56.361000', NULL, NULL, '1', 1, NULL, NULL, NULL, '7', 'test9', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '2', NULL, NULL, 4, 1, NULL);
INSERT INTO `u_user` VALUES (12, b'1', '2022-06-01 18:14:56.573000', '2022-06-01 18:14:56.573000', 'test10', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220607/85d47945-3f66-4b48-b07f-8b33b7372f30.jpg', '2022-06-15 18:11:56.361000', NULL, NULL, '1', 1, NULL, NULL, NULL, '7', 'test10', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '2', NULL, NULL, 4, 1, NULL);
INSERT INTO `u_user` VALUES (13, b'1', '2022-06-01 18:15:08.055000', '2022-06-01 18:15:08.055000', 'test11', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-06-15 18:11:56.361000', NULL, NULL, '1', 1, NULL, NULL, NULL, '7', 'test11', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '2', NULL, NULL, 4, 1, NULL);
INSERT INTO `u_user` VALUES (14, b'1', '2022-06-01 19:38:14.842000', '2022-06-01 19:38:14.842000', 'admin', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/191f1957-74ab-47aa-bae1-95cf00d45d72.png', '2022-06-22 19:37:12.982000', NULL, NULL, '1', 0, NULL, NULL, NULL, '1', 'admin', NULL, NULL, '8A86E5ABC9BB9C3C7A3FEED335656889', NULL, 1, 0, '1', NULL, NULL, 3, 1, NULL);
INSERT INTO `u_user` VALUES (15, b'1', '2022-06-01 19:40:20.776000', '2022-06-02 14:52:02.879566', 'test123', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-06-24 08:00:00.000000', NULL, NULL, '1', 0, NULL, NULL, NULL, '1', 'test123', NULL, NULL, 'E5B272ADC51B39B4F330F64B630EC26B', NULL, 1, 1, '1', NULL, NULL, 5, 1, NULL);
INSERT INTO `u_user` VALUES (16, b'1', '2022-06-01 21:49:44.853000', '2022-06-08 07:57:11.478000', 'test234', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/5d369fde-f7c5-481a-afa1-5ee11bc6719f.png', '2022-06-01 08:00:00.000000', NULL, NULL, '1', 1, NULL, NULL, NULL, '23', 'test234', NULL, NULL, '5E6D91DB96F9332C98D0633E3215E93B', NULL, 1, 1, '2', NULL, NULL, 5, 1, NULL);
INSERT INTO `u_user` VALUES (17, b'1', '2022-06-02 12:41:02.124000', '2022-06-08 07:56:59.030000', 'test555', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/7fae6a45-32d2-4c1d-b976-431da3021845.png', '2022-06-02 08:00:00.000000', NULL, NULL, '5', 0, NULL, NULL, NULL, '5', 'test555', NULL, NULL, '5E6D91DB96F9332C98D0633E3215E93B', NULL, 1, 1, '5', NULL, NULL, 5, 1, NULL);
INSERT INTO `u_user` VALUES (18, b'1', '2022-06-02 17:50:44.088000', '2022-06-08 07:56:10.800000', 'test11111', NULL, NULL, 'https://demo-platform.usefullc.com/system/common/res/system/20220608/191f1957-74ab-47aa-bae1-95cf00d45d72.png', '2022-06-02 08:00:00.000000', NULL, NULL, '1111', 0, NULL, NULL, NULL, '1111', '无敌手', NULL, NULL, '5E6D91DB96F9332C98D0633E3215E93B', NULL, 1, 1, '11111', NULL, NULL, 5, 1, '1111');
INSERT INTO `u_user` VALUES (19, b'1', '2022-06-04 23:40:55.676000', '2022-06-07 23:23:42.441000', 'admin2', NULL, '86', 'https://demo-platform.usefullc.com/system/common/res/system/20220607/85d47945-3f66-4b48-b07f-8b33b7372f30.jpg', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, '15267164683', 'admin2', NULL, NULL, '5E6D91DB96F9332C98D0633E3215E93B', NULL, 1, 1, 'admin2', NULL, NULL, 5, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for u_user_role
-- ----------------------------
DROP TABLE IF EXISTS `u_user_role`;
CREATE TABLE `u_user_role` (
  `userId` bigint NOT NULL,
  `roleId` bigint NOT NULL,
  KEY `FKjh0u12g42rt4md78ptxxnlpmu` (`roleId`) USING BTREE,
  KEY `FK8rsekkvn91inc4bkn6jxsayv4` (`userId`) USING BTREE,
  CONSTRAINT `FK8rsekkvn91inc4bkn6jxsayv4` FOREIGN KEY (`userId`) REFERENCES `u_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKjh0u12g42rt4md78ptxxnlpmu` FOREIGN KEY (`roleId`) REFERENCES `u_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of u_user_role
-- ----------------------------
BEGIN;
INSERT INTO `u_user_role` VALUES (2, 1);
INSERT INTO `u_user_role` VALUES (4, 1);
INSERT INTO `u_user_role` VALUES (5, 2);
INSERT INTO `u_user_role` VALUES (6, 1);
INSERT INTO `u_user_role` VALUES (7, 1);
INSERT INTO `u_user_role` VALUES (8, 1);
INSERT INTO `u_user_role` VALUES (10, 1);
INSERT INTO `u_user_role` VALUES (11, 1);
INSERT INTO `u_user_role` VALUES (12, 1);
INSERT INTO `u_user_role` VALUES (13, 1);
INSERT INTO `u_user_role` VALUES (14, 1);
INSERT INTO `u_user_role` VALUES (15, 1);
INSERT INTO `u_user_role` VALUES (1, 1);
INSERT INTO `u_user_role` VALUES (17, 1);
INSERT INTO `u_user_role` VALUES (16, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
